/* This do file creates figures for the online appendix. use the DoeBudgetOversight and the CleanAirActOversight datasets
to produce them */

use "Filepath\DoeBudgetOversight"

#delimit ;

/* Table A1 DOE Oversight Hearing Days */

drop if agency_witnesses==0;

twoway scatter over_days congress, mcolor(black)

xtitle("Congressional Session", height(5))

ytitle("No. of Oversight Days", height(7))

xlabel(97(2)115,angle(45) labsize(vsmall))

ylabel(1(2)5,labsize(vsmall))

title("Figure A1. No of Days during Oversight Hearings,",size(small) color(black))
subtitle("on the DOE Budget, 97th to 115th Congresses",size(small) color(black))
legend(off)
nodraw saving("Filepath\FigureA1") ;


/* Table A2 DOE Oversight Hearing Pages"  */

twoway scatter pages congress, mcolor(black)

xtitle("Congressional Session", height(5))

ytitle("No. of Oversight Days", height(7))

xlabel(97(2)115,angle(45) labsize(vsmall))

ylabel(0(200)800,labsize(vsmall))

title("Figure A2. No of Transcript Pages in Oversight Hearings",size(small) color(black))
subtitle("on the DOE Budget, 97th to 115th Congresses",size(small) color(black))
legend(off)
nodraw saving("Filepath\FigureA2") ;

clear;

use "Filepath\CleanAirActOversight" ;

/* Table A3 Clean Air Act Oversight Hearing Days */

drop if agency_witnesses==0;

twoway scatter over_days congress, mcolor(black)

xtitle("Congressional Session", height(5))

ytitle("No. of Oversight Days", height(7))

xlabel(92(2)112,angle(45) labsize(vsmall))

ylabel(1(3)10,labsize(vsmall))

title("Figure A3. No. of Days during Overisght Hearings on,",size(small) color(black))
subtitle("the Clean Air Act, 92nd to 112th Congresses",size(small) color(black))
legend(off)
nodraw saving("Filepath\FigureA3") ;


/* Table A4 Clean Air Act Oversight Hearing Pages" */

twoway scatter pages congress, mcolor(black)

xtitle("Congressional Session", height(5))

ytitle("No. of Oversight Days", height(7))

xlabel(92(2)112,angle(45) labsize(vsmall))

ylabel(0(500)2000,labsize(vsmall))

title("Figure A4. No of Transcript Pages in Oversight Hearings,",size(small) color(black))
subtitle("on the Clean Air Act, 92nd to 112th Congresses",size(small) color(black))
legend(off)
nodraw saving("Filepath\FigureA4") ;


